How to Resolve ORA

您所在的位置：网站首页 › oracle truncate nowait › How to Resolve ORA

How to Resolve ORA

2023-07-22 19:19| 来源: 网络整理| 查看: 265

ORA-00054

There're several cases that throw ORA-00054.

Alter Table Move Tablespace

We tried to move table to another tablespace.

SQL> show user USER is "HR" SQL> alter table employees move tablespace users; alter table employees move tablespace users * ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired Alter Table Read Only

Or tried to make the table read only.

SQL> alter table employees read only; alter table employees read only * ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired Drop Table

Even dropping the table is impossible.

SQL> drop table employees; drop table employees * ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired Create Index

We can't create index at this moment.

SQL> create index emp_mgr_idx on employees (manager_id); create index emp_mgr_idx on employees (manager_id) * ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired Alter Index

Next, we tried to rebuild index to another tablespace.

SQL> alter index emp_email_uk rebuild tablespace example; alter index emp_email_uk rebuild tablespace example * ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

ORA-00054 means that the table you want to operate with has a lock on it by someone else and it cannot release the lock at this moment. You need to wait for the lock released.

Solution

You need to told the owner to release the lock, a COMMIT or ROLLBACK is necessary to explicitly release the table lock, or you can kill sessions of the lock owner.

【本文地址】

How to Resolve ORA

How to Resolve ORA

今日新闻

推荐新闻